package com.guigu.common.mapper;


import com.guigu.common.pojo.SPayDetails;
import com.guigu.leizihao.vo.SpayDetailsView;
import com.guigu.leizihao.vo.SpayView;
import org.apache.ibatis.annotations.Update;

import java.util.List;

public interface SPayDetailsMapper {
    int deleteByPrimaryKey(Integer id);

    int insert(SPayDetails record);

    int insertSelective(SPayDetails record);

    SPayDetails selectByPrimaryKey(Integer id);

    int updateByPrimaryKeySelective(SPayDetails record);

    int updateByPrimaryKey(SPayDetails record);

    void addSpayDetail(List<SPayDetails> list);

    List<SpayView> findSpayDetailsById(Integer id);

    void sPayDetailsPayTag(Integer id);

    @Update("update s_pay_details set pay_tag='k002-3' where id=#{value}")
    int UpdateSpay_details(Integer id);

    int querySpay_detailsCount(Integer id);

    void updateSpay_detailsQuantityInStorage(List list);

    List<SpayView> findSpayDetailsByIdandQuantityIinStorage(Integer id);

    void updateSpayDetailsPaidAmount(List list);

    void updateSpayDetailsPayTagById(List<SPayDetails> list);

    Integer querySpayTotalcost(Integer id);

    List<SpayDetailsView> queryspayDetailsByproductId(String productid);
}